﻿CREATE TABLE [dbo].[Project]
(
	[ProjectId] INT NOT NULL PRIMARY KEY IDENTITY, 
    [ProductName] NVARCHAR(50) NULL, 
    [ProductIntroduction] TEXT NULL, 
    [ProductModel] NVARCHAR(50) NULL, 
    [ProductCount] INT NULL, 
    [DeliveryTime] DATETIME NULL, 
    [InvitationMatter] NVARCHAR(50) NULL, 
    [Head] NVARCHAR(50) NULL
)

GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'项目信息',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'Project',
    @level2type = NULL,
    @level2name = NULL
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'项目编号',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'Project',
    @level2type = N'COLUMN',
    @level2name = N'ProjectId'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'项目名称',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'Project',
    @level2type = N'COLUMN',
    @level2name = 'ProductName'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'项目简介',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'Project',
    @level2type = N'COLUMN',
    @level2name = 'ProductIntroduction'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'产品型号',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'Project',
    @level2type = N'COLUMN',
    @level2name = 'ProductModel'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'产品数量',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'Project',
    @level2type = N'COLUMN',
    @level2name = N'ProductCount'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'产品交货时间',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'Project',
    @level2type = N'COLUMN',
    @level2name = N'DeliveryTime'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'邀请事项',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'Project',
    @level2type = N'COLUMN',
    @level2name = N'InvitationMatter'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'负责人',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'Project',
    @level2type = N'COLUMN',
    @level2name = N'Head'